#!/bin/bash

#赵宗尧
#导出命令
sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_rpt_text \
--table rpt_absent \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_absent \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_rpt_text \
--table rpt_leave \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_leave \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_rpt_text \
--table rpt_late_signin \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_late_signin \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_rpt_text \
--table rpt_normal_signin \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_normal_signin \
-m 1